comparing two tables [closed]
Posted
by
sza
on Programmers
See other posts from Programmers
or by sza
Published on 2011-01-11T19:00:35Z
Indexed on
2011/01/11
19:59 UTC
Read the original article
Hit count: 171
sql-server
I have two identical table ie all the columns are identical and one of the datatype is Text, one is varchar(255) and the rest are int. Lets say the table name is 'AAAAA'. Table AAAAA was processed and backed up earlier this month. Both the tables were storing data and now the second table is only storing data. I need to find unmatching records from the second table (BBBBB) which is storing data right now and add those records to Table AAAAA.
Your help will be highly appreciated. I tried to use 'EXCEPT' but it does not support text datatype.
© Programmers or respective owner